﻿CREATE TABLE [dbo].[UndoOtherChanges] (
    [UndoOtherChangesID] INT            IDENTITY (1, 1) NOT NULL,
    [UndoAction]         NVARCHAR (10)  NOT NULL,
    [ChangedBy]          INT            NOT NULL,
    [WhenChanged]        DATETIME       NOT NULL,
    [ChangeLog]          NVARCHAR (MAX) NOT NULL,
    CONSTRAINT [PK_UndoOtherChanges] PRIMARY KEY CLUSTERED ([UndoOtherChangesID] ASC),
    CONSTRAINT [FK_UndoOtherChanges_DefinedUndoActions] FOREIGN KEY ([UndoAction]) REFERENCES [dbo].[DefinedUndoActions] ([UndoAction]),
    CONSTRAINT [FK_UndoOtherChanges_Entities] FOREIGN KEY ([ChangedBy]) REFERENCES [dbo].[Entities] ([EntityID])
);

